www.gusucode.com > WSTMall PHP网店系统 v1.6.0PHP源码程序 > WSTMall PHP网店系统 v1.6.0/wstmall_v1.6.0_160506/wstmall_v1.6.0_160506/Apps/Home/Model/BrandsModel.class.php
<?php namespace Home\Model; /** * ============================================================================ * WSTMall开源商城 * 官网地址:http://www.wstmall.com * 联系QQ:707563272 * ============================================================================ * 品牌服务类 */ class BrandsModel extends BaseModel { /** * 根据县区获取品牌列表 */ public function queryBrandsByDistrict(){ $areaId3 = (int)I("areaId3"); $brandName = WSTAddslashes(I("brandName")); $pcurr = (int)I("pcurr"); $sql = "SELECT bs.brandId,bs.brandName,bs.brandIco FROM __PREFIX__brands bs,__PREFIX__shops sp,__PREFIX__goods g,__PREFIX__goods_cat_brands gcb WHERE bs.brandId=g.brandId AND g.shopId=sp.shopId AND gcb.brandId=bs.brandId AND bs.brandFlag = 1"; if($areaId3>0){ $sql .= " AND sp.areaId3 = $areaId3"; } if($brandName!=""){ $sql .= " AND bs.brandName like '%$brandName%'"; } $sql.=" group by bs.brandId "; $brands = $this->pageQuery($sql,$pcurr,30); return $brands; } /** * 获取列表 */ public function queryBrandsByCat($catId){ $rs = array('status'=>1); $list = S("WST_BRANDS_002_".$catId); if(!$list){ $sql = "select b.brandId,b.brandName from __PREFIX__goods_cat_brands cb,__PREFIX__brands b where cb.brandId=b.brandId and b.brandFlag=1 and catId=".$catId; $rs['list'] = $this->query($sql); S("WST_BRANDS_002_".$catId,$list,2592000); } return $rs; } }